package com.teamall.web.tssy.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class TsSyRoleArg {
    private String pk_name = "ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<TsSyRoleCriteria> oredCriteria;

    public TsSyRoleArg() {
        oredCriteria = new ArrayList<TsSyRoleCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<TsSyRoleCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(TsSyRoleCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public TsSyRoleCriteria or() {
    	TsSyRoleCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public TsSyRoleCriteria createCriteria() {
    	TsSyRoleCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected TsSyRoleCriteria createCriteriaInternal() {
    	TsSyRoleCriteria criteria = new TsSyRoleCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<TsSyRoleCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<TsSyRoleCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<TsSyRoleCriterion> getAllCriteria() {
            return criteria;
        }

        public List<TsSyRoleCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new TsSyRoleCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new TsSyRoleCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new TsSyRoleCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new TsSyRoleCriterion(condition, value1, value2));
        }

        public TsSyRoleCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andIdIsNull() {
            addCriterion("ID is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdLessThan(String value) {
            addCriterion("ID <", value, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdLike(String value) {
            addCriterion("ID like ", value, "ID", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdNotLike(String value) {
            addCriterion("ID  not like ", value, "ID", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdLeftLike(String value) {
            addCriterion("ID like ", value, "ID", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdNotLeftLike(String value) {
            addCriterion("ID  not like ", value, "ID", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdRightLike(String value) {
            addCriterion("ID like ", value, "ID", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdNotRightLike(String value) {
            addCriterion("ID  not like ", value, "ID", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdIn(List<String> values) {
            addCriterion("ID  in ", values, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdNotIn(List<String> values) {
            addCriterion("ID not in ", values, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdBetween(String value1, String value2) {
            addCriterion("ID between ", value1, value2, "ID");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between ", value1, value2, "ID");
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andRoleNameIsNull() {
            addCriterion("ROLE_NAME is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameIsNotNull() {
            addCriterion("ROLE_NAME is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameEqualTo(String value) {
            addCriterion("ROLE_NAME =", value, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameNotEqualTo(String value) {
            addCriterion("ROLE_NAME <>", value, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameGreaterThan(String value) {
            addCriterion("ROLE_NAME >", value, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameGreaterThanOrEqualTo(String value) {
            addCriterion("ROLE_NAME >=", value, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameLessThan(String value) {
            addCriterion("ROLE_NAME <", value, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameLessThanOrEqualTo(String value) {
            addCriterion("ROLE_NAME <=", value, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameLike(String value) {
            addCriterion("ROLE_NAME like ", value, "ROLE_NAME", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameNotLike(String value) {
            addCriterion("ROLE_NAME  not like ", value, "ROLE_NAME", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameLeftLike(String value) {
            addCriterion("ROLE_NAME like ", value, "ROLE_NAME", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameNotLeftLike(String value) {
            addCriterion("ROLE_NAME  not like ", value, "ROLE_NAME", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameRightLike(String value) {
            addCriterion("ROLE_NAME like ", value, "ROLE_NAME", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameNotRightLike(String value) {
            addCriterion("ROLE_NAME  not like ", value, "ROLE_NAME", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameIn(List<String> values) {
            addCriterion("ROLE_NAME  in ", values, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameNotIn(List<String> values) {
            addCriterion("ROLE_NAME not in ", values, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameBetween(String value1, String value2) {
            addCriterion("ROLE_NAME between ", value1, value2, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRoleNameNotBetween(String value1, String value2) {
            addCriterion("ROLE_NAME not between ", value1, value2, "ROLE_NAME");
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkLike(String value) {
            addCriterion("REMARK like ", value, "REMARK", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkNotLike(String value) {
            addCriterion("REMARK  not like ", value, "REMARK", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkLeftLike(String value) {
            addCriterion("REMARK like ", value, "REMARK", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkNotLeftLike(String value) {
            addCriterion("REMARK  not like ", value, "REMARK", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkRightLike(String value) {
            addCriterion("REMARK like ", value, "REMARK", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkNotRightLike(String value) {
            addCriterion("REMARK  not like ", value, "REMARK", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkIn(List<String> values) {
            addCriterion("REMARK  in ", values, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in ", values, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between ", value1, value2, "REMARK");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between ", value1, value2, "REMARK");
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andIsDelIsNull() {
            addCriterion("IS_DEL is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelIsNotNull() {
            addCriterion("IS_DEL is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelEqualTo(String value) {
            addCriterion("IS_DEL =", value, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelNotEqualTo(String value) {
            addCriterion("IS_DEL <>", value, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelGreaterThan(String value) {
            addCriterion("IS_DEL >", value, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DEL >=", value, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelLessThan(String value) {
            addCriterion("IS_DEL <", value, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelLessThanOrEqualTo(String value) {
            addCriterion("IS_DEL <=", value, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelLike(String value) {
            addCriterion("IS_DEL like ", value, "IS_DEL", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelNotLike(String value) {
            addCriterion("IS_DEL  not like ", value, "IS_DEL", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelLeftLike(String value) {
            addCriterion("IS_DEL like ", value, "IS_DEL", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelNotLeftLike(String value) {
            addCriterion("IS_DEL  not like ", value, "IS_DEL", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelRightLike(String value) {
            addCriterion("IS_DEL like ", value, "IS_DEL", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelNotRightLike(String value) {
            addCriterion("IS_DEL  not like ", value, "IS_DEL", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelIn(List<String> values) {
            addCriterion("IS_DEL  in ", values, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelNotIn(List<String> values) {
            addCriterion("IS_DEL not in ", values, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelBetween(String value1, String value2) {
            addCriterion("IS_DEL between ", value1, value2, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andIsDelNotBetween(String value1, String value2) {
            addCriterion("IS_DEL not between ", value1, value2, "IS_DEL");
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateLike(Date value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateNotLike(Date value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateLeftLike(Date value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateNotLeftLike(Date value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateRightLike(Date value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateNotRightLike(Date value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andCreateByIsNull() {
            addCriterion("CREATE_BY is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByIsNotNull() {
            addCriterion("CREATE_BY is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByEqualTo(String value) {
            addCriterion("CREATE_BY =", value, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByNotEqualTo(String value) {
            addCriterion("CREATE_BY <>", value, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByGreaterThan(String value) {
            addCriterion("CREATE_BY >", value, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY >=", value, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByLessThan(String value) {
            addCriterion("CREATE_BY <", value, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY <=", value, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByLike(String value) {
            addCriterion("CREATE_BY like ", value, "CREATE_BY", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByNotLike(String value) {
            addCriterion("CREATE_BY  not like ", value, "CREATE_BY", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByLeftLike(String value) {
            addCriterion("CREATE_BY like ", value, "CREATE_BY", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByNotLeftLike(String value) {
            addCriterion("CREATE_BY  not like ", value, "CREATE_BY", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByRightLike(String value) {
            addCriterion("CREATE_BY like ", value, "CREATE_BY", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByNotRightLike(String value) {
            addCriterion("CREATE_BY  not like ", value, "CREATE_BY", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByIn(List<String> values) {
            addCriterion("CREATE_BY  in ", values, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByNotIn(List<String> values) {
            addCriterion("CREATE_BY not in ", values, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByBetween(String value1, String value2) {
            addCriterion("CREATE_BY between ", value1, value2, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY not between ", value1, value2, "CREATE_BY");
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andUpdateByIsNull() {
            addCriterion("UPDATE_BY is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByIsNotNull() {
            addCriterion("UPDATE_BY is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByEqualTo(String value) {
            addCriterion("UPDATE_BY =", value, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByNotEqualTo(String value) {
            addCriterion("UPDATE_BY <>", value, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByGreaterThan(String value) {
            addCriterion("UPDATE_BY >", value, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY >=", value, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByLessThan(String value) {
            addCriterion("UPDATE_BY <", value, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY <=", value, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByLike(String value) {
            addCriterion("UPDATE_BY like ", value, "UPDATE_BY", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByNotLike(String value) {
            addCriterion("UPDATE_BY  not like ", value, "UPDATE_BY", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByLeftLike(String value) {
            addCriterion("UPDATE_BY like ", value, "UPDATE_BY", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByNotLeftLike(String value) {
            addCriterion("UPDATE_BY  not like ", value, "UPDATE_BY", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByRightLike(String value) {
            addCriterion("UPDATE_BY like ", value, "UPDATE_BY", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByNotRightLike(String value) {
            addCriterion("UPDATE_BY  not like ", value, "UPDATE_BY", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByIn(List<String> values) {
            addCriterion("UPDATE_BY  in ", values, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByNotIn(List<String> values) {
            addCriterion("UPDATE_BY not in ", values, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByBetween(String value1, String value2) {
            addCriterion("UPDATE_BY between ", value1, value2, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY not between ", value1, value2, "UPDATE_BY");
            return (TsSyRoleCriteria) this;
        }
        public TsSyRoleCriteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeLike(Date value) {
            addCriterion("UPDATE_TIME like ", value, "UPDATE_TIME", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeNotLike(Date value) {
            addCriterion("UPDATE_TIME  not like ", value, "UPDATE_TIME", 1);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeLeftLike(Date value) {
            addCriterion("UPDATE_TIME like ", value, "UPDATE_TIME", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeNotLeftLike(Date value) {
            addCriterion("UPDATE_TIME  not like ", value, "UPDATE_TIME", 0);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeRightLike(Date value) {
            addCriterion("UPDATE_TIME like ", value, "UPDATE_TIME", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeNotRightLike(Date value) {
            addCriterion("UPDATE_TIME  not like ", value, "UPDATE_TIME", 2);
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME  in ", values, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in ", values, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between ", value1, value2, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

        public TsSyRoleCriteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between ", value1, value2, "UPDATE_TIME");
            return (TsSyRoleCriteria) this;
        }

    }

    public static class TsSyRoleCriteria extends GeneratedCriteria {

        protected TsSyRoleCriteria() {
            super();
        }
    }

    public static class TsSyRoleCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected TsSyRoleCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected TsSyRoleCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected TsSyRoleCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected TsSyRoleCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected TsSyRoleCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected TsSyRoleCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}